home *** CD-ROM | disk | FTP | other *** search
-
- ╔════════════════════════════════════════════════════════════════════════════╗
- ║ ║
- ║ ║
- ║ █▄██████████▒░ █████▒░ ██▒░ ██░ ███████████▒░ ║
- ║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
- ║ ██▒░ ██▒░ █▒░ █▒░ ██▒░ ██░ ██▒░ ██▒░ ║
- ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
- ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
- ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
- ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░██░ ██▒░ ██▒░ ║
- ║ ██▒░ ██▒░ ███▀▀▀▀▀███▒░ ████▒░ ██▒░ ██▒░ ║
- ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║
- ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║
- ║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║
- ║ █▀██████████▒░ ██▒░ ██▒░ ██▒░ ███████████▒░ ║
- ║ ░░░░░░░░░░░ ░░░ ░░░ ░░░ ░░░░░░░░░░░░ ║
- ║ ║
- ║ ║
- ║ ║
- ║ ███▒░ ███▒░ ███▒░ ║
- ║ ███▒░ ███▒░ ███▒░ ║
- ║ ███▒░ ███████▒░ ███████▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▄█████▒░ ║
- ║ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ║
- ║ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ║
- ║ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ████▄██▀ ███▒░ ███▒░ ███▒░ ███▒░ ║
- ║ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▀██▄ ███▒░ ███▒░ ███▀█████▒░ ║
- ║ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░███▒░ ███▒░ ███▒░ ███▒░ ║
- ║ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ║
- ║ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ║
- ║ ███████▒░ ████████▒░ ████████▒░ ███▒░ ███▒░ █████████▒░ ███▒░ ║
- ║ ███████▒░ ██████▒░ ██████▒░ ███▒░ ███▒░ ███████▒░ ███▒░ ║
- ║ ║
- ║ ║
- ║ DAYO DATABASE LOOK UP FOR VIEWING ONLY ║
- ║ ║
- ║ ║
- ║ Copyright (c) 1990, TJS LAB, PO Box 585366, Orlando, Florida 32858 ║
- ║ ║
- ║ ║
- ║ ▓▓▓▓▓▓ ███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌ ║
- ║ ▀ ▓▓ ▀ ▓▓▓▓ ▀▀▀▀▀███████████████████████████▌ S ║
- ║ ▓▓ ▓▓ ▄▓▓▓▄ ▀████▀▀ ▀████████████ O ║
- ║ ▓▓ ▓▓ ▓▓ ▀▀ ███████████ F ║
- ║ ▓▓ ▓▓ ▓▓ ▀▓▓▓▄ Specializing In ▐█████████▌ T ║
- ║ ▀▓▓▓▀ ▓▓ MicroComputer ██████████ C W ║
- ║ ▀▓▓▓▀ & LAN █████■████▌ O A ║
- ║ Applications ▐███████████ N R ║
- ║ ┌─┐ ┌─┐ ███████████▌ S E ║
- ║ ▀▓▓ ▓ ▀▓▄▓▓▓▄ ┌╧─╧┐ ┌─┐ ┌╧─╧┐ ████▀ ▀███ U ║
- ║ ▓▓ ▓▓▓ ▓▓ ▓▓ └───╜ ┌╧─╧┐ └───╜ ███ ██▌ L & ║
- ║ ▓▓ ▄▓ ▓▄ ▓▓▓▓▓ ░█░ └───╜ ░█░ ███▄▄███ T ║
- ║ ▓▓ ▓▓▓▓▓ ▓▓ ▓▓ █████ ░█░ █████ ▀█████▌ I ║
- ║ ▓▓▓▓ ▄▓ ▓▄ ▓▀▓▓▓▀ █████ ▀▀▀█ N ║
- ║ █ G ║
- ║ PO BOX 585366, ORLANDO, FLORIDA 32858 ▄▄▄▄▀ ║
- ║ ║
- ╚════════════════════════════════════════════════════════════════════════════╝
- DAYO Look Up, TJS LAB
-
-
-
-
-
-
-
- ■ SOFTWARE SUPPORT POLICY
-
-
- 1. TJS LAB does not support users of unregistered DAYO products with the
- exception of installation questions.
-
- 2. Support (included with registration) remains in effect for 1 year after
- date of registration or upgrade.
-
- 3. Support is available through the following methods:
-
- - Phone/Voice Mail: (407) 291-3960/6987
-
- - U.S. Mail: TJS LAB, PO Box 585366, Orlando, FL 32858-5366
-
- - Compuserve Easyplex: 76367,1401
-
- 4. Any errors ("bugs or features') in the program will be corrected and
- the 'fix' sent promptly (via modem if possible).
-
- DAYO Look Up, TJS LAB Page: 1
-
-
-
-
-
-
- Table of Contents
-
-
-
- Page Subject
- ──── ───────────────────────────────────────
- 2 ............... INTRODUCTION
- 2 ............... COPYRIGHT/LICENSE
- 3 ............... DISCLAIMER
- 3 ............... REQUIREMENTS ***
- 3 ............... SETUP
- 4 ............... MAIN MENU
- 4 ............... EXIT TO DOS
- 5 ............... DEFAULT DAYO DATABASE LISTING
- 5 ............... DATABASE PASSWORD
- 6 ............... VIEW ONLY BROWSE
- 7 ............... MEMO/NOTE FIELDS
- 8 ............... EXAMPLE OF READING/VIEWING MEMO/NOTE FIELDS
- 8 ............... FULL SCREEN VIEWING OF THE DATA - F2 & F3
- 8 ............... CONFIGURATION
- 9 ............... PASSWORD
- 9 ............... CONFIGURATION MENU
- 10 ............... COLOR MONITOR
- 10 ............... COLOR INTENSITY
- 11 ............... MAINTENANCE OF THE LOOK UP DATABASES
- 12 ............... FULL SCREEN EDIT (LOOKUP.DBF) - F2
- 12 ............... ADD NEW RECORD (LOOKUP.DBF) - CTRL N
- 12 ............... DELETE A RECORD (LOOKUP.DBF) - CTRL U
- 12 ............... FIND KEY - F5
- 13 ............... HELP SCREENS
- 14 ............... EXPANDED HELP
- 15 ............... USER DEFINED & INPUTTED HELP SCREENS/MESSAGES
- 16 ............... VIEW DOCUMENTATION ONSCREEN
- 17 ............... DATABASE STRUCTURE
- 17 ............... DATA DICTIONARY
- 18 ............... DAYO LOOK UP MAINTENANCE & QUIRKS
- 19 ............... TJS 'Computer' LAB
- DAYO Look Up, TJS LAB Page: 2
-
-
-
-
- ■ INTRODUCTION
-
- DAYO Look Up is a routine used by DAYO users to view data from any DAYO
- or dBase (tm) compatible database (.DBF). No editing of the data is allowed.
- This which provides a 'safe' tool for users that do not have the need to
- make changes the the databases.
-
-
- Some of the DAYO Look Up highlights are:
-
- Multiuser (ie: Novell)
- Databases are dBase (tm) compatible
- Configuration Password (with DAYO Passwords)
- Database Passwords for Each Menu Selection
- Multiple Indexes
- Over 45 Databases to View
- Memo field viewing
-
-
- Other DAYO Products:
-
-
- DAYO Inventory Inventory Control, Vendors, Purchasing, Receiving
- DAYO POS Point of Sales Billing & Invoicing
- DAYO Quotes Sales Quoting System
- DAYO Price Books Special pricing for your customers as well as a wide
- range of product catalogs/reports
- DAYO AR Accounts Receivable
- DAYO AP Accounts Payable
- DAYO EOP End of Period Post & Pack, Physical Inventory
- DAYO BO Back Orders
- DAYO GL General Ledger
- DAYO MRP Materials Requirement Planning (MRP)
- DAYO Smart Reports A variety of reports pertaining to the above modules
- DAYO Passwords Password protect your DAYO system
- DAYOX Network/LAN Index Maintenance Utility
-
-
-
- ■ COPYRIGHT/LICENSE
-
- This manual and software is copyrighted with all rights reserved by
- TJS LAB. No copying of this manual or software is authorized without
- the prior written consent of TJS LAB. An exception to this rule is the
- making of backup copies of registered software disks. No RESALE of any part
- of the source codes is authorized without the prior written consent of
- TJS LAB. TJS LAB retains all rights to DAYO Look Up software, documentation,
- and source codes.
-
- DAYO Look Up, TJS LAB Page: 3
-
-
-
- ■ DISCLAIMER
-
- No warrant is made that this software will work in all environments,
- or with all resident programs and hardware configurations. TJS LAB has
- tested this software in many environments and found it to perform as
- expected, however, this software is licensed "AS IS".
-
- TJS LAB will not be liable for any damage done to your data, hardware,
- and/or software systems as a result of using DAYO Look Up.
-
-
-
- ■ REQUIREMENTS ***
-
- IBM or Compatible CPU
-
- 640K memory
-
- * DOS 3.3 or above
-
- Hard Disk
-
-
-
- ■ SETUP
-
- To setup DAYO Look Up, copy the contents of the DAYO Look Up floppy disk
- into a directory on your hard disk (ie: \DAYOLU). When running DAYO Look Up
- for the first time, it will create all the database, index, and
- configuration files it requires for operation. If you are using other DAYO
- modules, be sure to enter the location of these databases into the DAYO Look
- Up configuration.
-
- *** Your CONFIG.SYS file must have the buffers set to a minimum of 10, and
- your files must have a MINIMUM setting of 55! Failure to edit the CONFIG.SYS
- file is the #1 cause for DAYO installation problems! A CONFIG.SYS file is
- created if there is a problem detected, in the directory that this DAYO
- module is being run in. You may copy this file into your root/boot drive.
- Refer to your DOS manual for more information on the CONFIG.SYS file!
- DAYO Look Up, TJS LAB Page: 4
-
-
-
- ■ MAIN MENU
-
-
- DAYO Lookup Version 3.0 TJS LAB ┌───[February 1991]──┐
- Copyright (c) 1990-1991, All Rights Reserved │S M T W T F S │
- ╓───────────────────────╖ ├────────────────────┤
- ║ LOOK UP DAYO DATABASES║ █▄██▄ ▄█▄ █░ █░ ▄███▄ │ 1 2│
- ╟───────────────────────╢ █░ █░ █░█░ █░ █░ █░ █░ │ 3 4 5 6 7 8 9│
- ║AP Detail ║ █░ █░ █░█░ ▀█░██░ █░ █░ │10 11 12 13 14 15 16│
- ║AP Headers ║ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │17 18 19 20 21 22 23│
- ║AR Detail ║ █░ █░ █░ █░ █░ █░ █░ │24 25 26 27 28 │
- ║AR Headers ║ █▀██▀ █░ █░ █░ ▀███▀ │ │
- ║AR Ship Tos ║ └────────────────────┘
- ║AR Shippers ║
- ║AR Taxcodes/Rates ║
- ║AR Terms ║
- ║AR Types ║ ██░ █████░ █████░ ██░ ██░ ██░ ██░ ██▄████░
- ║Applied Cash ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░
- ║Back Orders ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░
- ║Banking Accounts ║ ██░ ██░ ██░ ██░ ██░ ██▄█▀ ██░ ██░ ██▀████░
- ║Cash Receipts ║ ██░ ██░ ██░ ██░ ██░ ██▀█▄ ██░ ██░ ██░
- ║Check Printing Formats ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░
- ║Checks ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░
- ║Customer Notes ║ █████░ █████░ █████░ ██░ ██░ █████░ ██░
- ╠╦╦╦═════════════════╦╦╦╣
- ╠╬╬╣ Select Database ╠╬╬╣
- ╚╩╩╩═════════════════╩╩╩╝
- Name: AP Detail Database: APD.DBF Location: \DAYOAP\
-
-
-
- ■ EXIT TO DOS
-
- At the main menu, press Esc to bring up the Exit window. Press Y to exit
- back to DOS.
-
- ╔═══════════════╗
- ║╔═════════════╗║
- ║║╔═══════════╗║║
- ║║║QUIT? (Y/N)║║║
- ║║╚═══════════╝║║
- ║╚═════════════╝║
- ╚═══════════════╝
- DAYO Look Up, TJS LAB Page: 5
-
-
-
- ■ DEFAULT DAYO DATABASE LISTING
-
-
- The following DAYO databases are created for viewing with this module:
-
-
- AP Detail Inventory
- AP Headers Inventory Adjustments
- AR Detail Invoice Detail
- AR Headers Invoice Headers
- AR Ship Tos Invoice Templates
- AR Shippers MRP Bill of Materials
- AR Taxcodes/Rates MRP End Items
- AR Terms Physical Inventory
- AR Types Price Book
- Applied Cash Purchase Order Detail
- Back Orders Purchase Order Headers
- Banking Accounts Quote Notes
- Cash Receipts Quotes Detail
- Check Printing Formats Quotes Headers
- Checks Receiving
- Customer Notes Recurring Checks
- Customers Registers
- Deposits Sales Persons
- Expenses Serial Numbers
- GL Chart of Accounts Vendors
- GL Class Codes Warehouse Names
- GL Transactions Warehouses
- Indexing File Work Order Notes
-
- + many others...
-
-
-
- ■ DATABASE PASSWORD
-
-
- Each Database option can have a password of its own (maintained by the
- 'Look Up Databases' configuration). Upon entry into each database, you will
- be prompted for the password. If the password is the same for subsequent
- accesses into other databases, the prompt for the password will not appear.
-
- The default password for all the databases is 'DAYO'.
-
-
- ┌──────────────────────────────────────────────────────────────────────────┐
- │┌────────────────────────────────────────────────────────────────────────┐│
- ││ Enter Access Password for Database -> ARD.DBF: DAYO ││
- ││ Default Password is 'DAYO' ││
- │└────────────────────────────────────────────────────────────────────────┘│
- └──────────────────────────────────────────────────────────────────────────┘
- DAYO Look Up, TJS LAB Page: 6
-
-
-
-
- ■ VIEW ONLY BROWSE
-
-
- From the main menu, select the database you wish to view. A browse
- screen will appear allowing your users to read and view ONLY.
-
- If any indexes are available, the find keys will be displayed on the
- bottom line.
-
- Press F1 (Help) for more information on the special keys in the browse
- screens.
-
- Note, remember that there are usually many more fields to the right of
- the current window screen. Use the arrow keys to view them.
-
-
- DAYO Lookup Version 3.0 █░ ▄██▄ ▄██▄ █░ █░ █░ █░ █▄██░
- █░ █░ █░ █░ █░ █▄█▀ █░ █░ █░ █░
- █░ █░ █░ █░ █░ ██▄▄ █░ █░ █▀▀▀
- ███░ ▀██▀ ▀██▀ █░ █░ ▀██▀ █░
- ╔════════════════════════════════════════════════════════════════════════════╗
- ║ Database Name: AR Detail ║
- ║ Number of Records: 464 ║
- ║ Size: 49571 ║
- ╟────────────────────────────────────────────────────────────────────────────╢
- ║INVOICE ITEM DESC QTY PRICE ║
- ╟────────╥──────────────╥──────────────────────────────╥─────────╥───────────╢
- ║ 21 ║ 9022 ║ CAR, RED ║ 31 ║ 5007.00║
- ║ 21 ║ 9030 ║ CAR, BLUE ║ 4 ║ 5007.00║
- ║ 22 ║ 9007 ║ CAR, OLD ║ 102 ║ 2200.00║
- ║ 22 ║ 9015 ║ BUMPER, 5 YEARS OLD ║ 1 ║ 38.00║
- ║ 22 ║ 9022 ║ BOX OF SCREW DRIVERS ║ 1 ║ 147.00║
- ║ 22 ║ 9030 ║ BOX OF PS MATRIXS ║ 1 ║ 12040.00║
- ║ 22 ║ 9037 ║ BOX OF CRAYONS ║ 1 ║ 3.00║
- ║ 23 ║ 9007 ║ BOX OF CRAYONS, YELLOW ║ 1 ║ 3.00║
- ║ 23 ║ 9015 ║ BOX, MISC ║ 2 ║ 25.00║
- ║ 23 ║ 9022 ║ BOX, MISC II ║ 3 ║ 35.00║
- ╚════════╩══════════════╩══════════════════════════════╩═════════╩═══════════╝
- Esc (Exit) F1 (Help) F2 (View 1) F3 (View 2)
- 384/464
- DAYO Look Up, TJS LAB Page: 7
-
-
-
- ■ MEMO/NOTE FIELDS
-
-
- Some DAYO databases contain a Memo type field that is useful for
- recording text data on customers, orders, or whatever... Current DAYO
- databases that contain a Memo type field are:
-
-
- CUSTMEMO.DBF - in DAYO AR
- WO_NOTES.DBF in DAYO POS
- QUONOTES.DBF in DAYO QUOTES
-
-
- ╔════════════════════════════════════════════════════════════════════════════╗
- ║ Database Name: Customer Notes ║
- ║ Number of Records: 5 ║
- ║ Size: 184 ║
- ╟────────────────────────────────────────────────────────────────────────────╢
- ║ CUSTOMER NOTES ║
- ╟─────────────────────────────────────╥──────────────────────────────────────╢
- ║ 234 ║ <Memo> ║
- ║ 324 ║ <Memo> ║
- ║ 342 ║ <Memo> ║
- ║ 343 ║ <Memo> ║
- ║ ║ ║
- ║ ║ ║
- ║ ║ ║
- ║ ║ ║
- ╚═════════════════════════════════════╩══════════════════════════════════════╝
-
-
- DAYO Look Up, TJS LAB Page: 8
-
-
-
- ■ EXAMPLE OF READING/VIEWING MEMO/NOTE FIELDS
-
-
- To view the contents of a Memo type field, just highlight the field
- marked <Memo>, and press enter/return.
-
- A window will appear onto the screen displaying the memo/notes (if any
- exist).
-
-
- ╔═══════════════════════[ Read/View Memo Field: NOTES ]══════════════════════╗
- ║ Last attempt to call this customer was on 12 May, 1990. Talked to Salley ║
- ║ about a partial payment on the supplies that were received in the town ║
- ║ in Ohio... ║
- ║ 14 May - Salley called to say she sent the payment... ║
- ║ 16 May - Received the payment, but was short $12,000. Called Salley, but ║
- ║ got no answer... Left word with Agent Smith to give her a call! ║
- ║ ║
- ║ ║
- ║ ║
- ║ ║
- ║ ║
- ╚══════════════════════════[ Esc (Exit) F1 (Help) ]════════════════════════╝
-
-
- Use the arrow and PgUp/PgDn keys to move around the Memo type field.
- Press F1 for more information on the special keys.
-
-
-
- ■ FULL SCREEN VIEWING OF THE DATA - F2 & F3
-
-
- Two options for viewing all the fields in the selected database are
- available.
-
- Press F2 to bring up a screen consisting of up to two columns of data
- (up to 42 fields at once on the screen).
-
- Press F3 to bring up a full screen scroll of the currently highlighted
- record. You must use the arrow keys to scroll to fields in databases with
- many fields.
-
-
-
- ■ CONFIGURATION
-
-
- Only 3 configuration 'options' exist for DAYO Look Up: Color Monitor,
- Color Intensity, and the Maintenance Browse for the DAYO Look Up database
- LOOKUP.DBF.
- DAYO Look Up, TJS LAB Page: 9
-
-
-
- ■ PASSWORD
-
- On initial entry into the configuration menu, a prompt will appear onto
- the screen requesting your password (if DAYO Passwords has been installed)
- or your name. Some entry must be made at this point.
-
-
- ┌──────────────────────────────────────────────────────────────────────────┐
- │┌────────────────────────────────────────────────────────────────────────┐│
- ││ Enter Your Name: GEORGE MOONILAL ││
- ││ DAYO Passwords not installed in this directory... ││
- │└────────────────────────────────────────────────────────────────────────┘│
- └──────────────────────────────────────────────────────────────────────────┘
-
-
-
- ■ CONFIGURATION MENU
-
- If you successfully enter your password or name, the very large and
- impressive configuration menu is displayed onto the upper left of the
- screen (you may have to look hard...).
-
-
-
- DAYO Lookup Version 3.0 TJS LAB CONFIG ┌───[February 1991]──┐
- ╔════════════════════════╗ │S M T W T F S │
- ║ CONFIGURATION ║ █▄██▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤
- ╟────────────────────────╢ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2│
- ║ Color ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 3 4 5 6 7 8 9│
- ║ High Intensity ║ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │10 11 12 13 14 15 16│
- ║ Look Up Databases ║ █░ █░ █░ █░ █░ █░ █░ │17 18 19 20 21 22 23│
- ║ ║ █▀██▀ █░ █░ █░ ▀███▀ │24 25 26 27 28 29 30│
- ╟────────────────────────╢ │ │
- ║ Select Option ║ └────────────────────┘
- ╠╦╦╦╦╦╦╦╦╦╦╦╦╦╦╦╦╦╦╦╦╦╦╦╦╣
- ╚╩╩╩╩╩╩╩╩╩╩╩╩╩╩╩╩╩╩╩╩╩╩╩╩╝
-
- ██░ █████░ █████░ ██░ ██░ ██░ ██░ ██▄████░
- ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░
- ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░
- ██░ ██░ ██░ ██░ ██░ ██▄█▀ ██░ ██░ ██▀████░
- ██░ ██░ ██░ ██░ ██░ ██▀█▄ ██░ ██░ ██░
- ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░
- ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░
- █████░ █████░ █████░ ██░ ██░ █████░ ██░
-
- DAYO Look Up, TJS LAB Page: 10
-
-
-
-
- ■ COLOR MONITOR
-
- ┌─────────────────────────────[ COLOR MONITOR ]──────────────────────────────┐
- │ If you have a color monitor and wish to display colors, then select Y, │
- │ (YES), else select N (NO) for monochrome and others. │
- │ The default is color, high intensity │
- │ │
- │ Do you have a color monitor? (Y/N) │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
-
- ■ COLOR INTENSITY
-
- ┌────────────────────────────[ COLOR INTENSITY ]─────────────────────────────┐
- │ Intensity is only applicable with color set to Y. │
- │ It will make your colors brighter... │
- │ │
- │ Set Color Intensity On? (Y/N) │
- └────────────────────────────────────────────────────────────────────────────┘
- DAYO Look Up, TJS LAB Page: 11
-
-
-
-
- ■ MAINTENANCE OF THE LOOK UP DATABASES
-
-
- This is the routine for the maintenance of the Look Up database
- LOOKUP.DBF. This database determines which other DAYO databases are to be
- viewed by this module. The Look Up database contains 10 fields that control
- what is available for your users to view. Read the Data Dictionary section
- for more information on the meanings of the fields.
-
- DAYO Look Up comes complete with 46 records of DAYO databases. You can
- add more if you wish.
-
-
- DAYO Lookup Version 3.0 TJS LAB CONFIG ┌───[February 1991]──┐
- ╔══════════════════[ MAINTENANCE OF THE LOOK UP DATABASES ]══════════════════╗
- ║ This routine is used to maintenance, edit, view and browse all databases ║
- ║ to be used with DAYO Look Up. ║
- ║ This option should only be accessed by the System Manager. ║
- ╟────────────────────────────────────────────────────────────────────────────╢
- ║ Database: APD.DBF Name: AP Detail ║
- ║ Location: \DAYOAP\ ║
- ║ Size: 21491 # Records: 154 Last Access: 06/18/90 ║
- ║ Comment: ║
- ╟────────────────────────────────────────────────────────────────────────────╢
- ║DATABASE NAME LOCATION ║
- ║─────────────╥────────────────────────────────╥─────────────────────────────║
- ║APD.DBF ║ AP Detail ║ \DAYOAP\ ║
- ║APH.DBF ║ AP Headers ║ \DAYOAP\ ║
- ║ARD.DBF ║ AR Detail ║ \DAYOAR\ ║
- ║ARH.DBF ║ AR Headers ║ \DAYOAR\ ║
- ║SHIPTOS.DBF ║ AR Ship Tos ║ \DAYOAR\ ║
- ║SHIPPER.DBF ║ AR Shippers ║ \DAYOPOS\ ║
- ║TAXCODES.DBF ║ AR Taxcodes/Rates ║ \DAYOPOS\ ║
- ║TERMS.DBF ║ AR Terms ║ \DAYOPOS\ ║
- ║TYPE.DBF ║ AR Types ║ \DAYOPOS\ ║
- ╚════════════════════════════════════════════════════════════════════════════╝
- Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete) F5 (Find)
- 11/46
- DAYO Look Up, TJS LAB Page: 12
-
-
-
-
- ■ FULL SCREEN EDIT (LOOKUP.DBF) - F2
-
-
- DAYO Lookup Version 3.0 TJS LAB CONFIG ┌───[February 1991]──┐
- ┌──────────────────────[ FULL SCREEN EDIT - LOOKUP.DBF ]─────────────────────┐
- │ DATABASE: APD.DBF │
- │ NAME: AP Detail │
- │ LOCATION: \DAYOAP\ │
- │ PASSWORD: DAYO │
- │ DATE: 06/18/90 │
- │ LASTDATE: 06/18/90 │
- │ COMMENT: │
- │ ACCESSES: 2 │
- │ SIZE: 21491 │
- │ NUMRECORDS: 154 │
- │ │
- │ │
- │ │
- │ │
- │ │
- └────────────────────────────────────────────────────────────────────────────┘
- Press Esc to Abort, PgUp/PgDn to Save and Exit
-
-
-
- ■ ADD NEW RECORD (LOOKUP.DBF) - CTRL N
-
- Press Ctrl N to add a blank record to the database LOOKUP.DBF. Use the
- Full Screen Edit option (F2) to edit it.
-
-
-
- ■ DELETE A RECORD (LOOKUP.DBF) - CTRL U
-
- Press Ctrl U to delete a record. If the database can be opened
- exclusively, the record will be PACKed out permanently.
-
-
-
- ■ FIND KEY - F5
-
-
- The DAYO Look Up database LOOKUP.DBF is indexed on the database NAME
- field.
-
-
- Press F5 to bring up a prompt to find a record based on the name of the
- database:
-
-
- ┌─────────────────────────────────────────────────────────────┐
- │ Enter NAME: AP Detail │
- └───────────────────────────────────────────────────TJS LAB───┘
- DAYO Look Up, TJS LAB Page: 13
-
-
-
- ■ HELP SCREENS
-
- - While in the browse screens, some of the option windows, and in the SIMPLE
- EDITOR, pressing the F1 key, will display a help screen.
-
- - BROWSE help:
-
- ┌───────────────────────[ DAYOLU HELP: DBEDIT, 0, ]──────────────────────────┐
- │ │
- │- Special keys for 'moving around' the BROWSE screen are: │
- │ │
- │ Left Arrow Key - Move to next field to your left │
- │ Right Arrow Key - Move to next field to your right │
- │ Ctrl Home - Go to the leftmost field │
- │ Ctrl End - Go to the rightmost field (on the end of the record)│
- │ Up Arrow - Move highlight to the previous record │
- │ Down Arrow - Move highlight to the next record │
- │ PgUp - Page up a full screen of records │
- │ PgDn - Page down a full screen of records │
- │ Ctrl PgUp - Go to the beginning of the file │
- │ Ctrl PgDn - Go to the end or last record of the file │
- │ Ctrl N - Add a record (where applicable) │
- │ Ctrl U - Delete a record (where applicable) │
- │ F5,F6,F7 - To seek/find a record based upon the active index │
- │ Esc - Exit the current operation │
- │ │
- │ Remember that there are many more fields to the right of the screen. │
- │ Press the right arrow key to view them... │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
- - Option Box Help:
-
- ┌─────────────────────────[ DAYOLU HELP: ACHOICE, 0, ]───────────────────────┐
- │ │
- │ │
- │ │
- │ │
- │ - Special keys for 'moving around' the Option Box are: │
- │ │
- │ Up Arrow - Move up one option │
- │ Down Arrow - Move down one option │
- │ PgUp - Page up multiple records │
- │ PgDn - Page down multiple records │
- │ Esc - ABORT and Exit │
- │ │
- │ │
- │ After highlighting the option you desire, press Enter... │
- │ │
- │ │
- │ │
- └────────────────────────────────────────────────────────────────────────────┘
- DAYO Look Up, TJS LAB Page: 14
-
-
-
- - Editor help:
-
- ┌───────────────────────[ DAYOLU HELP: MEMOEDIT, 0, ]────────────────────────┐
- │ │
- │ - Special keys for 'moving around' the EDITOR screen are: │
- │ │
- │ Left Arrow Key - Move to your left │
- │ Right Arrow Key - Move to your right │
- │ Ctrl Home - Go to the top, leftmost corner of window │
- │ Ctrl End - Go to the bottom, rightmost corner of window │
- │ Up Arrow - Move up one line │
- │ Down Arrow - Move down one line │
- │ PgUp - Page up a full screen │
- │ PgDn - Page down a full screen │
- │ Ctrl PgUp - Go to the beginning of the file │
- │ Ctrl PgDn - Go to the end of the file │
- │ Ctrl W - SAVE Changes and Exit │
- │ Esc - ABORT Changes and Exit │
- │ F2 - Import another text file into your document │
- │ │
- │ The margin may exceed the boundaries on the right side of the screen, │
- │ but the text is easily accessed using the special keys above... │
- │ │
- │ │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
-
- ■ EXPANDED HELP
-
- After Version 1.3, expanded help routines were added to all DAYO modules.
- At almost all prompts and menus you can press F1 for help. Help can be a
- function key message as displayed on previous page, a message that you have
- created (user defined & inputted), or the ability to read the documentation
- on the screen (saves paper).
- DAYO Look Up, TJS LAB Page: 15
-
-
-
- ■ USER DEFINED & INPUTTED HELP SCREENS/MESSAGES
-
- If you press F1 and no user defined & inputted message exists for that
- section of the program you are currently in you will receive a message to
- this effect, and then a blank/empty screen.
-
- The editing keys for this option are the same as for the Simple Editor
- (previous page).
-
-
- DAYO Lookup Version 3.0 TJS LAB ┌───[February 1991]──┐
- ┌──────[ DAYO HELP Called by Program: DAYOLU Variable: OPT ]───────┐
- │ │
- │ │
- │ │
- │ │
- │ │
- │ │
- │ ╔════════════════════════════════════════════════════════╗ │
- │ ║ No Online Help Messages Exist for this prompt... ║ │
- │ ║ ║ │
- │ ║ You can type in any help message you wish, or ║ │
- │ ║ press F1 to view the document for DAYOLU. ║ │
- │ ║ ║ │
- │ ║ ║ │
- │ ║ Press any key to continue... ║ │
- │ ╚════════════════════════════════════════════════════════╝ │
- │ │
- │ │
- ├───────────────────────────────────────────────────────────────────────────┤
- │ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) │
- └───────────────────────────────────────────────────────────────────────────┘
-
-
- If you wish to input anything at this point, just type whatever you
- wish, remembering to press Ctrl W to save all changes. Pressing Esc will
- not save ANY changes ( all effort you put into writing a help message will
- be lost! ).
- DAYO Look Up, TJS LAB Page: 16
-
-
-
- DAYO Lookup Version 3.0 TJS LAB ┌───[February 1991]──┐
- ┌───────[ DAYO HELP Called by Program: DAYOLU Variable: OPT ]───────┐
- │ │
- │ │
- │ │
- │ │
- │ Type in anything you wish about this portion of the program! │
- │ │
- │ The length of this file can be many pages... │
- │ │
- │ Be sure to press Ctrl W to save any changes/additions you make to this │
- │ screen. │
- │ │
- │ │
- │ │
- │ │
- │ │
- │ │
- ├────────────────────────────────────────────────────────────────────────────┤
- │ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) 13/4 │
- └────────────────────────────────────────────────────────────────────────────┘
-
-
-
- ■ VIEW DOCUMENTATION ONSCREEN
-
- To view the documentation for the module you are in, it must first exist
- in the current directory. Document files are named the same as the module,
- and have the extension of '.DOC', ie: DAYOINV.DOC, DAYOPOS.DOC, DAYOLU.DOC.
- Press F1 in the User Defined & Inputted Help Message screen to display the
- document (user manual). The special keys in this option are displayed in the
- Help Screen (press F1 again) for this option:
-
-
- ╔══════════════════════════════════════════════════════════════════════════╗
- ║ While viewing the document for DAYOPAY the keyboard is configured ║
- ║ as followed: ║
- ║ ║
- ║ Esc Exit ║
- ║ F5 Find a string. This search is not case sensitive ║
- ║ Examples: PAGE: 50 ║
- ║ INTRODUCTION ║
- ║ REPORTS ║
- ║ Home Return to the beginning of the document ║
- ║ End Go to the bottom of the document ║
- ║ PgUp Page up ║
- ║ ║
- ║ Any other key moves acts like PgDn (page down) ║
- ║ ║
- ║ Press any key to continue... ║
- ╚══════════════════════════════════════════════════════════════════════════╝
- DAYO Look Up, TJS LAB Page: 17
-
-
-
- ■ DATABASE STRUCTURE
-
-
-
- Database: LOOKUP.DBF
-
-
- Field Field name Type Width Dec Start End
- ───── ────────── ───────── ───── ─── ───── ───
- 1 DATABASE Character 12 1 12
- 2 NAME Character 30 13 42
- 3 LOCATION Character 30 43 72
- 4 PASSWORD Character 7 73 79
- 5 DATE Date 8 80 87
- 6 LASTDATE Date 8 88 95
- 7 COMMENT Character 70 96 165
- 8 ACCESSES Numeric 8 166 173
- 9 SIZE Numeric 10 174 183
- 10 NUMRECORDS Numeric 8 184 191
- ────────── ─────
- Total 192
-
-
-
- ■ DATA DICTIONARY
-
-
- Field Name Type Len Dec Database Description/Comments
- ────────── ──── ─── ─── ──────────── ──────────────────────────────────
- DATABASE C 12 0 LOOKUP.DBF Database File Name, ie: INV.DBF
- NAME C 30 0 LOOKUP.DBF Name of the database. Anything you
- want to write (up to 30
- characters)
- LOCATION C 30 0 LOOKUP.DBF Drive/Directory where the database
- resides, ie: \DAYOINV\
- Be sure to use the correct
- backslashes...
- PASSWORD C 7 0 LOOKUP.DBF Database password to be used when
- a user attempts to view the
- database
- DATE D 8 0 LOOKUP.DBF Date record was added
- LASTDATE D 8 0 LOOKUP.DBF Date last accessed
- COMMENT C 70 0 LOOKUP.DBF Comment field
- ACCESSES N 8 0 LOOKUP.DBF Number of accesses. Computer
- maintained
- SIZE N 10 0 LOOKUP.DBF Size of the database. Computer
- maintained
- NUMRECORDS N 8 0 LOOKUP.DBF Number of records in the database.
- Computer maintained
- DAYO Look Up, TJS LAB Page: 18
-
-
-
- ■ DAYO LOOK UP MAINTENANCE & QUIRKS
-
-
- - If you are on a multiuser network, you must 'flag' (change file attributes)
- of all files to make them sharable, readable and writable. Note that the
- command/program 'flag' may be called by a different name on your network.
-
-
- ie:
-
- E:\>FLAG *.NTX SRW
-
- or just to be safe, go ahead and flag all files in the DAYO directory:
-
- E:\>FLAG *.* SRW
-
-
- - Backups of your data and configuration files should take place daily! You
- have no doubt heard many 'scare' stories about losing data. They are all
- true! The key files that need to be backed up all have the extension of
- .DBF, .DBT, and .CFG. The .DBF files are your databases. The .DBT files
- are notes/memos. The .CFG file(s) contain your configuration information
- (as seen in the Configuration module).
-
- - If you are on a network, it is NOT recommended that you use dBase III+ with
- the databases. It may write an end of file marker not always recognized by
- DAYO. Appending additional records to the database after this point often
- leads/creates a 'bad record' in the database.
-
- - If you must use dBase (tm) with DAYO Look Up, and you are on a PC based
- network/LAN, be sure to SET EXCLUSIVE OFF before you open ANY databases.
- This will allow the opened databases to be shared, and more importantly,
- prevent a user (or all users!) from 'crashing'!
-
- DAYO Look Up, TJS LAB Page: 19
-
-
-
- ■ TJS 'Computer' LAB
-
- TJS LAB is an association of programmers and technicians that produce
- customized, multiuser software for the PC based network (ie: Novell and
- others). Our specialties include Inventory Control, PC Communications/EDI,
- Management, Reports (standard and graphic), Data Conversions, and
- Accounting (A/R, A/P).
-
- A unique feature of TJS LAB is that our software is by default, multiuser.
- 'Standalone' applications are the exception! All our applications are
- written in Clipper, Basic, or C (preferably Basic or Clipper). We will
- license all our application source codes. We produce applications that work,
- are easy to use, and are inexpensive!
-
- Want a change?
- Want an enhancement!
- Want a completely new product/application?
- Want to make your idea a reality?
-
- Custom/contract programming, by TJS LAB, and our associates is available.
-
- Standard rate is $35.00 per hour (our sites). Guaranteed quality and timely
- work is our number one policy.
-
- We make program enhancements/changes/fixes at our location(s), but can/do
- make 'house calls' via special software and a modem.
-
-
- Write us at:
-
- TJS LAB
- PO Box 585366
- Orlando, Florida 32858-5366
-
- Or call us (8:00 am - 11:00 pm):
-
- (407) 291-3960
-
-
- * Note that TJS LAB, nor any of the associates accept/take any support
- calls for unregistered products.
-
-
-
- TJS LAB, Computer Division
-
- In an effort to provide the 'total solution', TJS LAB now offers personal
- computer systems, printers, software and accessories at a much discounted
- price. All equipment is warranted by the manufacturer for at least one year.
- Call or write us for more information...
-
-